County Profile for Franklin - 2017



County Controls Information

Cost Report Counts Population
Total Hospital Count 1 Total Population on July 31, 2017 0
Total Cost Reports Filed in 2017 1 Total Births 0
Total Cost Reports Submitted 0 Total Deaths 0
Total Cost Reports Settled 1 Net Population Natural Change 0
Total Cost Reports Reopened 0 Total International Migration 0
Total Cost Reports Ammended 0 Total Domestic Migration 0
Total Cost Reports Audited 0 Total Residual 0
Net Population Change 0

County Financial Statements - Worksheet G

Balance Sheet Income Statement
Current Assets 10,898,396 Total Charges 36,284,515
Fixed Assets 2,316,036 Contract Allowance 15,920,090
Other Assets 0 Operating Revenue 20,364,425
Total Assets 13,214,432 Operating Expenses 23,613,481
Current Liabilities 27,343,772 Operating Margin -3,249,056
Long Term Liabilities 299,714 Other Income 467,042
Total Equity -14,429,054 Other Expense 0
Total Liabilities and Equity 13,214,432 Net Profit or Loss -2,782,014

County Calculations

Per Discharge Statistics Per Bed Statistics Per Person Statistics
Revenue per Discharge $162,915 Revenue per Bed $814,577 Revenue per Person $20,364,425
Net Margin per Discharge ($25,992) Net Margin per Bed ($129,962) Net Margin per Person ($3,249,056)
Net Profit per Discharge ($22,256) Net Profit per Bed ($111,281) Net Profit per Person ($2,782,014)
Net Fixed Assets per Discharge $18,528 Net Fixed Assets per Bed $92,641 Net Fixed Assets per Bed $2,316,036
Long Term Debt per Discharge $2,398 Long Term Debt per Bed $11,989 Long Term Debt per Person $299,714
Persons per Discharge 0 Persons per Bed 0
Occupancy Rate 73.3 %
Length of Stay 51 Days

County Ranking of Selected Values

Income Statement Balance Sheet Statistics
Total Charges 1,969 Net Fixed Assets 2,266 Population Estimate 1,151
Total Revenue 1,872 Long Term Liabilities 1,980 Total Patient Discharges 2,323
Net Margin 2,429 Total Patient Beds 2,030
Net Profit or Loss 2,957

County Charges and Direct Cost - Worksheet B and C

Line Description Direct Cost Charges Ratio
30 Adults and Pediatrics - General Routine Care 7,606,601 8,909,903 0.8537
31 Intensive Care Unit 0 0
32 Coronary Care Unit 0 0
43 Nursery 0 0
44 Skilled Nursing Care 0 0
50 Operating Room 640,760 1,680,866 0.3812
51 Recovery Room 0 0
52 Labor and Delivery Room 0 0

County General Service Cost - Worksheet A

Lines Description Amount Lines Description Amount
01 Capital Related - Building and Fixtures 234,910 13 Nursing Administration 1,502,625
02,03 Captial Related - Movable Equipment 896,719 14 Central Services and Supply 0
04 Employee Benefits 2,721,302 15 Pharmacy 0
05 Administrative and General 4,111,212 16 Medical Records and Medical Library 226,966
06 Maintenance and Repairs 0 17 Social Services 0
07 Operation of Plant 468,537 18 Other General Service Expense 0
08,09 Laundry, Linen and Housekeeping 482,687 19 Non Physician Anesthetist 0
10,11 Dietary and Cafeteria 339,249 20,21,22,23 Education Programs 0
Total General Service Cost Centers 10,984,207

County Profile for Franklin - 2017